//***************************************注册界面************************************************************
    /// <summary>
    /// 向用户表中插入信息
    /// </summary>
    /// <param name="P_Str_Name">会员名</param>
    /// <param name="P_Bl_Sex">性别</param>
    /// <param name="P_Str_Password">密码</param>
    /// <param name="P_Str_TrueName">真实姓名</param>
    /// <param name="P_Str_Questions">找回密码问题</param>
    /// <param name="P_Str_Answers">找回密码答案</param>
    /// <param name="P_Str_Phonecode">电话号码</param>
    /// <param name="P_Str_Emails">E_Mail</param>
    /// <param name="P_Str_City">会员所在城市</param>
    /// <param name="P_Str_Address">会员详细地址</param>
    /// <param name="P_Str_PostCode">邮编</param>
    /// <param name="P_Flt_AdvancePayment">预付金额</param>
    /// <param name="P_Date_LoadDate">登录日期</param>
    public int AddUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Pr_InsertUInfo", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        Name.Value = P_Str_Name;
        myCmd.Parameters.Add(Name);

        SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit, 1);
        sex.Value = P_Bl_Sex;
        myCmd.Parameters.Add(sex);

        SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
        Password.Value = P_Str_Password;
        myCmd.Parameters.Add(Password);

        SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50);
        TrueName.Value = P_Str_TrueName;
        myCmd.Parameters.Add(TrueName);

        SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50);
        Questions.Value = P_Str_Questions;
        myCmd.Parameters.Add(Questions);

        SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50);
        Answers.Value = P_Str_Answers;
        myCmd.Parameters.Add(Answers);

        SqlParameter Phonecode = new SqlParameter("@Phonecode", SqlDbType.VarChar, 20);
        Phonecode.Value = P_Str_Phonecode;
        myCmd.Parameters.Add(Phonecode);

        SqlParameter Emails = new SqlParameter("@Emails", SqlDbType.VarChar, 50);
        Emails.Value = P_Str_Emails;
        myCmd.Parameters.Add(Emails);

        SqlParameter City = new SqlParameter("@City", SqlDbType.VarChar, 50);
        City.Value = P_Str_City;
        myCmd.Parameters.Add(City);

        SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 200);
        Address.Value = P_Str_Address;
        myCmd.Parameters.Add(Address);

        SqlParameter PostCode = new SqlParameter("@PostCode", SqlDbType.Char, 10);
        PostCode.Value = P_Str_PostCode;
        myCmd.Parameters.Add(PostCode);

        SqlParameter MemberId = myCmd.Parameters.Add("@MemberId", SqlDbType.BigInt, 8);
        MemberId.Direction = ParameterDirection.Output;
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);

        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();
        }
        return Convert.ToInt32(MemberId.Value.ToString());

    }
    /// <summary>
    /// 修改会员充值
    /// </summary>
    /// <param name="P_Int_MemberID">会员ID</param>
    /// <param name="P_Flt_AdvancePayment">充值金额</param>
    public void UpdateAP(int P_Int_MemberID, float P_Flt_AdvancePayment)
    {
        SqlConnection myConn = dbObj.GetConnection();
        SqlCommand myCmd = new SqlCommand("Pr_UpdateAP", myConn);
        myCmd.CommandType = CommandType.StoredProcedure;
        //添加参数
        SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
        MemberID.Value = P_Int_MemberID;
        myCmd.Parameters.Add(MemberID);

        SqlParameter AdvancePayment = new SqlParameter("@AdvancePayment", SqlDbType.Float, 8);
        AdvancePayment.Value = P_Flt_AdvancePayment;
        myCmd.Parameters.Add(AdvancePayment);
        //执行过程
        myConn.Open();
        try
        {
            myCmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw (ex);

        }
        finally
        {
            myCmd.Dispose();
            myConn.Close();
        }


    }